﻿CREATE PROCEDURE [dbo].[Hogar_Remito_Obtener] 
 @RemitoId INT
AS 
BEGIN

/*****************************************************************************************************************************************/
-- Author: Carlos Mendoza
-- Purpose:   obtener el remito por id 
-- Returns:    Remito
/*****************************************************************************************************************************************/ 
	
	SELECT [RemitoId],
			[NumeroRemito],
			[FechaEntrega],
			ISNULL([Observacion],'') AS [Observacion],
			[ProveedorId]
	FROM	[dbo].[Remito]  WITH (NOLOCK)
	WHERE [RemitoId] = @RemitoId
	
END